﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ConfirmTableList.aspx.cs" Inherits="Family_ConfirmTableList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>浏览图书确认信息表</title>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
        .style2
        {
            height: 27px;
            font-size: large;
            background-color: #CCCCCC;
        }
        .style3
        {
            height: 27px;
            font-size: large;
            text-align: right;
        }
    </style>
</head>
<body style="margin:0;" >
    <form id="form1" runat="server">
    <div>
    
        <table class="style1">
            <tr>
                <td style="text-align: center; background-color: #CCCCCC;" class="style3">
                    <strong>图书确认信息表</strong></td>
            </tr>
            <tr>
                <td  class="style3">
                    <a href="ConfirmBookArrived.aspx" style="text-align: right">跳转到图书确认页</a></td>
            </tr>
            <tr>
                <td style="text-align: center">
                    <asp:Button ID="Button1" runat="server" Text="导出图书确认信息表到Excel" 
                        OnClientClick="return confirm('需要导出确认信息表吗？')" onclick="Button1_Click" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="Button2" runat="server" Text="清除图书确认信息表" 
                        OnClientClick="return confirm('一定要清除吗？')" onclick="Button2_Click" />
                </td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView1" runat="server" Width="100%" AllowPaging="True" 
                        AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" 
                        DataSourceID="sds1" ForeColor="#333333" GridLines="None" PageSize="20">
                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        <Columns>
                            <asp:BoundField DataField="图书编号" HeaderText="图书编号" SortExpression="图书编号" />
                            <asp:BoundField DataField="书名" HeaderText="书名" ReadOnly="True" 
                                SortExpression="书名" />
                            <asp:BoundField DataField="图书流向" HeaderText="图书流向" ReadOnly="True" 
                                SortExpression="图书流向" />
                            <asp:BoundField DataField="借书学生" HeaderText="借书学生" ReadOnly="True" 
                                SortExpression="借书学生" />
                            <asp:BoundField DataField="年级1" HeaderText="年级1" ReadOnly="True" 
                                SortExpression="年级1" />
                            <asp:BoundField DataField="班级1" HeaderText="班级1" ReadOnly="True" 
                                SortExpression="班级1" />
                            <asp:BoundField DataField="电话1" HeaderText="电话1" ReadOnly="True" 
                                SortExpression="电话1" />
                            <asp:BoundField DataField="持有人姓名" HeaderText="持有人姓名" ReadOnly="True" 
                                SortExpression="持有人姓名" />
                            <asp:BoundField DataField="年级2" HeaderText="年级2" ReadOnly="True" 
                                SortExpression="年级2" />
                            <asp:BoundField DataField="班级2" HeaderText="班级2" ReadOnly="True" 
                                SortExpression="班级2" />
                            <asp:BoundField DataField="电话2" HeaderText="电话2" ReadOnly="True" 
                                SortExpression="电话2" />
                            <asp:BoundField DataField="借出确认时间" HeaderText="借出确认时间" 
                                SortExpression="借出确认时间" />
                            <asp:BoundField DataField="还入确认时间" HeaderText="还入确认时间" 
                                SortExpression="还入确认时间" />
                        </Columns>
                        <EditRowStyle BackColor="#999999" />
                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <PagerSettings Position="Top" />
                        <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Center" />
                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                        <SortedAscendingCellStyle BackColor="#E9E7E2" />
                        <SortedAscendingHeaderStyle BackColor="#506C8C" />
                        <SortedDescendingCellStyle BackColor="#FFFDF8" />
                        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                    </asp:GridView>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:SqlDataSource ID="sds1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:DataConn %>" onselected="sds1_Selected" 
                        SelectCommand="Get_Admin_Confirm_Yes_List" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp; 共计：<asp:Label ID="msg1" runat="server" Font-Bold="True" ForeColor="#FF3300"></asp:Label>
                    条&nbsp;</td>
            </tr>
            <tr>
                <td class="style2" style="text-align: center">
                    <strong>图书借阅信息一览表</strong></td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView2" runat="server" Width="100%" AllowPaging="True" 
                        AllowSorting="True" AutoGenerateColumns="False" BackColor="White" 
                        BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" 
                        DataSourceID="sds2" ForeColor="Black" GridLines="Vertical" PageSize="20">
                        <AlternatingRowStyle BackColor="White" />
                        <Columns>
                            <asp:BoundField DataField="图书编号" HeaderText="图书编号" SortExpression="图书编号" />
                            <asp:BoundField DataField="书名" HeaderText="书名" ReadOnly="True" 
                                SortExpression="书名" />
                            <asp:BoundField DataField="图书流向" HeaderText="图书流向" ReadOnly="True" 
                                SortExpression="图书流向" />
                            <asp:BoundField DataField="借书学生" HeaderText="借书学生" ReadOnly="True" 
                                SortExpression="借书学生" />
                            <asp:BoundField DataField="年级1" HeaderText="年级1" ReadOnly="True" 
                                SortExpression="年级1" />
                            <asp:BoundField DataField="班级1" HeaderText="班级1" ReadOnly="True" 
                                SortExpression="班级1" />
                            <asp:BoundField DataField="电话1" HeaderText="电话1" ReadOnly="True" 
                                SortExpression="电话1" />
                            <asp:BoundField DataField="持有人姓名" HeaderText="持有人姓名" ReadOnly="True" 
                                SortExpression="持有人姓名" />
                            <asp:BoundField DataField="年级2" HeaderText="年级2" ReadOnly="True" 
                                SortExpression="年级2" />
                            <asp:BoundField DataField="班级2" HeaderText="班级2" ReadOnly="True" 
                                SortExpression="班级2" />
                            <asp:BoundField DataField="电话2" HeaderText="电话2" ReadOnly="True" 
                                SortExpression="电话2" />
                            <asp:BoundField DataField="借出确认时间" HeaderText="借出确认时间" 
                                SortExpression="借出确认时间" />
                            <asp:BoundField DataField="还入确认时间" HeaderText="还入确认时间" 
                                SortExpression="还入确认时间" />
                        </Columns>
                        <FooterStyle BackColor="#CCCC99" />
                        <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
                        <PagerSettings Position="Top" />
                        <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Center" />
                        <RowStyle BackColor="#F7F7DE" />
                        <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
                        <SortedAscendingCellStyle BackColor="#FBFBF2" />
                        <SortedAscendingHeaderStyle BackColor="#848384" />
                        <SortedDescendingCellStyle BackColor="#EAEAD3" />
                        <SortedDescendingHeaderStyle BackColor="#575357" />
                    </asp:GridView>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:SqlDataSource ID="sds2" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:DataConn %>" onselected="sds2_Selected" 
                        SelectCommand="Get_Admin_Confirm_No_List" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp; 共计：<asp:Label ID="msg2" runat="server" Font-Bold="True" ForeColor="#FF3300"></asp:Label>
                    条&nbsp;&nbsp;</td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
